Date handling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone

I need to write some code to return the date of the last working day (Fri) of the current week. This is so I can run a query to select very specific data from my base. Is there a built in function or can anyone tell me a way of doing this. Thanks in advance.
 
The Friday that ends this week:
=Date() - Weekday(Date(), 7) + 7

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Russell Lucas said:
I need to write some code to return the date of the last working day (Fri)
Click to expand...
of the current week. This is so I can run a query to select very specific
data from my base. Is there a built in function or can anyone tell me a way
of doing this. Thanks in advance.
 
Back
Top