If function date problem
Closed
zombie_hunter
-
2 Feb 2015 à 11:49
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 2 Feb 2015 à 12:54
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 - 2 Feb 2015 à 12:54
Related:
- If function date problem
- Hard drive function - Guide
- Network card function - Guide
- Mutator function c++ - Guide
- Find function on mac - Guide
- Excel color function - Guide
2 responses
pijaku
Posts
13513
Registration date
Wednesday 14 May 2008
Status
Moderator
Last seen
4 January 2024
1
2 Feb 2015 à 12:43
2 Feb 2015 à 12:43
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 31 August 2010
Status
Contributor
Last seen
20 June 2016
26
2 Feb 2015 à 12:54
2 Feb 2015 à 12:54
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