Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 
					
				
		
how to find out last week date from current date
.png) 
					
				
		
 Miguel_Angel_Ba
		
			Miguel_Angel_BaHello,
Use
=WeekEnd(CurrentDate)
Hope this helps
 
					
				
		
this will give the week end days , but i want to know the lask week date , means last date when was friday .
 
					
				
		
try to use this expression: =Date(Num(Date(Now()))-7)
.png) 
					
				
		
 Miguel_Angel_Ba
		
			Miguel_Angel_BaHello,
Use instead
=LastWorkDate(WeekStart(Date(DateFieldName)), 5)
Hope this helps
 
					
				
		
Hi, use this function
weekend
(Date,-1,5)