| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date question
Hello,
I am trying to create a formula that will give the result of "friday" if payday falls on a Saturday or Sunday. I am assuming that I need an If/Then function, but I am not sure how to do this with dates. For example, If payday is on 8/1/2009, it will give me the result of "Friday" Thank you very much for your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date question
hi
with the date in A1, in B1 enter =Text(A1,"dddd") regards FSt1 "jennifer" wrote: Hello, I am trying to create a formula that will give the result of "friday" if payday falls on a Saturday or Sunday. I am assuming that I need an If/Then function, but I am not sure how to do this with dates. For example, If payday is on 8/1/2009, it will give me the result of "Friday" Thank you very much for your help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date question
I am not sure what "dddd" means....
"FSt1" wrote: hi with the date in A1, in B1 enter =Text(A1,"dddd") regards FSt1 "jennifer" wrote: Hello, I am trying to create a formula that will give the result of "friday" if payday falls on a Saturday or Sunday. I am assuming that I need an If/Then function, but I am not sure how to do this with dates. For example, If payday is on 8/1/2009, it will give me the result of "Friday" Thank you very much for your help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date question
jennifer wrote:
Hello, I am trying to create a formula that will give the result of "friday" if payday falls on a Saturday or Sunday. I am assuming that I need an If/Then function, but I am not sure how to do this with dates. For example, If payday is on 8/1/2009, it will give me the result of "Friday" Thank you very much for your help! Is this what you want? =IF(WEEKDAY(A1,2)=6,"Friday","") Of course, I do not know when your paydays are. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date question
hi
it the format. if you enter"dddd", it will say Friday if you enter "ddd", it will say Fri if you enter "mmmm", it will July if yo enter "mmm" , it will say jul you did specify the full day name and not just the abriviation. read up on the text function in help. Regards FSt1 "jennifer" wrote: I am not sure what "dddd" means.... "FSt1" wrote: hi with the date in A1, in B1 enter =Text(A1,"dddd") regards FSt1 "jennifer" wrote: Hello, I am trying to create a formula that will give the result of "friday" if payday falls on a Saturday or Sunday. I am assuming that I need an If/Then function, but I am not sure how to do this with dates. For example, If payday is on 8/1/2009, it will give me the result of "Friday" Thank you very much for your help! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date question
Yes, Thank you very much! I did not have the If/Then statement just right...
"smartin" wrote: jennifer wrote: Hello, I am trying to create a formula that will give the result of "friday" if payday falls on a Saturday or Sunday. I am assuming that I need an If/Then function, but I am not sure how to do this with dates. For example, If payday is on 8/1/2009, it will give me the result of "Friday" Thank you very much for your help! Is this what you want? =IF(WEEKDAY(A1,2)=6,"Friday","") Of course, I do not know when your paydays are. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date question | Excel Discussion (Misc queries) | |||
| Date Question | Excel Worksheet Functions | |||
| DATE Question | Excel Worksheet Functions | |||
| Date Question | Excel Discussion (Misc queries) | |||
| DATE Question | Excel Discussion (Misc queries) | |||
Linear Mode
