If function date problem
Closed
zombie_hunter
-
Feb 2, 2015 at 11:49 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Feb 2, 2015 at 12:54 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Feb 2, 2015 at 12:54 PM
Related:
- If function date problem
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Hard drive function - Guide
2 responses
pijaku
Posts
12263
Registration date
Wednesday May 14, 2008
Status
Moderator
Last seen
January 4, 2024
1
Feb 2, 2015 at 12:43 PM
Feb 2, 2015 at 12:43 PM
Hello,
Try the WEEKDAY function. I don't know with an English Excel but with a French one : WEEKDAY(Date Cell) = 2 If date cell is a monday
So you can try a formula like :
=IF(WEEKDAY(B3)=2,F3-C3,IF(WEEKDAY(B3)=4,G3-C3,"not monday or wednesday"))
Try the WEEKDAY function. I don't know with an English Excel but with a French one : WEEKDAY(Date Cell) = 2 If date cell is a monday
So you can try a formula like :
=IF(WEEKDAY(B3)=2,F3-C3,IF(WEEKDAY(B3)=4,G3-C3,"not monday or wednesday"))
RayH
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
26
Feb 2, 2015 at 12:54 PM
Feb 2, 2015 at 12:54 PM
Note sure which day you are using, Wednesday or Thursday?
Anyway you can use the WEEKDAY function to return the day number:
=IF(WEEKDAY(B3)=2,F3-C3,IF(WEEKDAY(B3)=5,G3-C3,"") )
Where WEEKDAY returns one of the following:
Sunday 1
Monday 2
Tuesday 3
Wednesday 4
Thursday 5
Friday 6
Saturday 7
Anyway you can use the WEEKDAY function to return the day number:
=IF(WEEKDAY(B3)=2,F3-C3,IF(WEEKDAY(B3)=5,G3-C3,"") )
Where WEEKDAY returns one of the following:
Sunday 1
Monday 2
Tuesday 3
Wednesday 4
Thursday 5
Friday 6
Saturday 7