route217
asked on
Date formula
Hi Experts
I have in cell c2 ="w/e"&text(now(),"dd mmm yy" which is fine but I want to insert a similar
Formula in cell b2 less 7 days and in a2 less 14 days...
I have in cell c2 ="w/e"&text(now(),"dd mmm yy" which is fine but I want to insert a similar
Formula in cell b2 less 7 days and in a2 less 14 days...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Solved it....
As text use
="TEXT(NOW(),"dddd dd mmm" )
as a date just use =Now() and use custom format the cell to "dddd dd mmm"
Michael
="TEXT(NOW(),"dddd dd mmm" )
as a date just use =Now() and use custom format the cell to "dddd dd mmm"
Michael
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How would I amend to show date as Friday 04 Jan in cell c2